articles

Home / DeveloperSection / Articles / Line Graph in Excel

Line Graph in Excel

AVADHESH PATEL4148 28-Mar-2013

Line graphs are used to display data in style way for pictorial format. In another words line graph is used to display data according time based. This is particularly helpful when including data in a presentation. You will, however, see the word "chart" in most of the help files and instructions. The information below will help you make a line graph in Microsoft Excel step by step.

Step 1: First create excel sheet with some dummy data as below

Line Graph in Excel

Step 2: Now select range of data which you display into line graph as below image

Line Graph in Excel

Step 3: Now, go to “Insert” menu and select “Line” option as below image.

Line Graph in Excel

After selecting “Line Graph” your data look as below

Line Graph in Excel

Step 4: For more stylish line open Chart Type option and chose your style as below image.

Line Graph in Excel


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By